﻿CREATE TABLE [dbo].[RaportareFoiBoala] (
    [IDFoaieBoala]          INT           IDENTITY (1, 1) NOT NULL,
    [IDPersoana]            INT           NOT NULL,
    [MedicPrescriptor]      VARCHAR (100) NOT NULL,
    [UnitateaSanitaraMedic] VARCHAR (150) NOT NULL,
    [DataAnuntare]          DATETIME      NOT NULL,
    [DataUpdate]            DATETIME      CONSTRAINT [DF_RaportareFoiBoala_DataUpdate] DEFAULT (getdate()) NOT NULL,
    CONSTRAINT [PK_RaportareFoiBoala] PRIMARY KEY CLUSTERED ([IDFoaieBoala] ASC),
    CONSTRAINT [FK_RaportareFoiBoala_Persoane] FOREIGN KEY ([IDPersoana]) REFERENCES [dbo].[Persoane] ([IdPersoana])
);

